{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys\n",
    "sys.path.append('..')\n",
    "from configure.settings import DBSelector"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "db = DBSelector()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "mongo_db = db.mongo()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "product_doc=mongo_db['fund']['etf_product']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "product_list =[]\n",
    "for item in product_doc.find({},{'_id':0}):\n",
    "    product_list.append(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'etf_code': '000001',\n",
       "  'etf_name': '上证指数',\n",
       "  'etf_product': ['汇添富上证综合指数', '富国上证综指ETF', '富国上证综指ETF联接', '国泰上证综合ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000010',\n",
       "  'etf_name': '上证180',\n",
       "  'etf_product': ['万家180指数', '华安上证180ETF', '华安上证180ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000012',\n",
       "  'etf_name': '国债指数',\n",
       "  'etf_product': ['南方高股息股票A', '南方高股息股票C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000015',\n",
       "  'etf_name': '红利指数',\n",
       "  'etf_product': ['华泰柏瑞上证红利ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000300',\n",
       "  'etf_name': '沪深300',\n",
       "  'etf_product': ['博时沪深300指数A',\n",
       "   '长盛全债指数增强债券',\n",
       "   '长城久泰沪深300指数A',\n",
       "   '嘉实沪深300ETF联接(LOF)A',\n",
       "   '大成沪深300指数A/B'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000905',\n",
       "  'etf_name': '中证500',\n",
       "  'etf_product': ['南方中证500ETF联接(LOF)A',\n",
       "   '广发500ETF联接(LOF)A',\n",
       "   '鹏华中证500指数(LOF)A',\n",
       "   '富国中证500指数增强(LOF)',\n",
       "   '农银中证500指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000914',\n",
       "  'etf_name': '300金融',\n",
       "  'etf_product': ['国投金融地产ETF联接基金', '国投瑞银金融地产ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000919',\n",
       "  'etf_name': '300价值',\n",
       "  'etf_product': ['银河沪深300价值指数', '申万沪深300价值指数A', '申万沪深300价值指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H11014',\n",
       "  'etf_name': '中证短融',\n",
       "  'etf_product': ['海富通中证短融ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000029',\n",
       "  'etf_name': '180价值',\n",
       "  'etf_product': ['华宝兴业上证180价值ETF', '华宝上证180价值ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000037',\n",
       "  'etf_name': '上证医药',\n",
       "  'etf_product': ['华夏医药ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000925',\n",
       "  'etf_name': '基本面50',\n",
       "  'etf_product': ['嘉实基本面50指数(LOF)A', '嘉实基本面50指数(LOF)C', '嘉实中证锐联基本面50ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000042',\n",
       "  'etf_name': '上证央企',\n",
       "  'etf_product': ['工银上证央企50ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000046',\n",
       "  'etf_name': '上证中小',\n",
       "  'etf_product': ['华泰柏瑞上证中小盘ETF', '华泰柏瑞上证中小盘ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000933',\n",
       "  'etf_name': '中证医药',\n",
       "  'etf_product': ['汇添富中证医药卫生ETF',\n",
       "   '嘉实中证医药卫生ETF',\n",
       "   '鹏华中证医药A(LOF)',\n",
       "   '添富中证医药ETF联接A',\n",
       "   '添富中证医药ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000935',\n",
       "  'etf_name': '中证信息',\n",
       "  'etf_product': ['鹏华中证信息技术指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931461',\n",
       "  'etf_name': '电子50',\n",
       "  'etf_product': ['华宝中证电子50ETF', '华安中证电子50ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000944',\n",
       "  'etf_name': '内地资源',\n",
       "  'etf_product': ['民生加银中证内地资源主题指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000949',\n",
       "  'etf_name': '中证农业',\n",
       "  'etf_product': ['富国中证农业主题ETF', '银华中证农业主题ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000056',\n",
       "  'etf_name': '上证国企',\n",
       "  'etf_product': ['中银上证国企100ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000901',\n",
       "  'etf_name': '小康指数',\n",
       "  'etf_product': ['南方小康ETF', '南方小康ETF联接A', '南方小康ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000961',\n",
       "  'etf_name': '中证上游',\n",
       "  'etf_product': ['国投瑞银中证资源指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000963',\n",
       "  'etf_name': '中证下游',\n",
       "  'etf_product': ['国投瑞银中证消费服务指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000066',\n",
       "  'etf_name': '上证商品',\n",
       "  'etf_product': ['国联安上证商品ETF', '国联安上证商品ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399701',\n",
       "  'etf_name': '深证F60',\n",
       "  'etf_product': ['深证基本面60ETF', '建信深证基本面60ETF联接A', '建信深证基本面60ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399702',\n",
       "  'etf_name': '深证F120',\n",
       "  'etf_product': ['嘉实深证基本面120ETF', '嘉实深证基本面120ETF联接A', '嘉实深证基本面120ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000969',\n",
       "  'etf_name': '300非周',\n",
       "  'etf_product': ['长安沪深300非周期指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000009',\n",
       "  'etf_name': '上证380',\n",
       "  'etf_product': ['南方上证380ETF联接A', '南方上证380ETF', '南方上证380ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000971',\n",
       "  'etf_name': '等权90',\n",
       "  'etf_product': ['银华中证等权重90指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000978',\n",
       "  'etf_name': '医药100',\n",
       "  'etf_product': ['国联安中证医药100A',\n",
       "   '天弘中证医药100指数A',\n",
       "   '天弘中证医药100指数C',\n",
       "   '国联安中证医药100C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000984',\n",
       "  'etf_name': '300等权',\n",
       "  'etf_product': ['中银沪深300等权重指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000986',\n",
       "  'etf_name': '全指能源',\n",
       "  'etf_product': ['广发中证全指能源ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000991',\n",
       "  'etf_name': '全指医药',\n",
       "  'etf_product': ['广发中证全指医药卫生交易ETF',\n",
       "   '广发医药卫生联接A',\n",
       "   '广发医药卫生联接C',\n",
       "   '银华中证全指医药卫生指数增强发起式'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000993',\n",
       "  'etf_name': '全指信息',\n",
       "  'etf_product': ['广发中证全指信息技术交易ETF', '广发信息技术联接ETFA', '广发信息技术联接ETFC'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399959',\n",
       "  'etf_name': '军工指数',\n",
       "  'etf_product': ['前海开源中航军工指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H11136',\n",
       "  'etf_name': '中国互联网',\n",
       "  'etf_product': ['交银中证海外中国互联网指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000802',\n",
       "  'etf_name': '500沪市',\n",
       "  'etf_product': ['中证500沪市ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000998',\n",
       "  'etf_name': '中证TMT',\n",
       "  'etf_product': ['中信保诚中证TMT产业主题指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000805',\n",
       "  'etf_name': 'A股资源',\n",
       "  'etf_product': ['鹏华中证A股资源产业指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000808',\n",
       "  'etf_name': '医药生物',\n",
       "  'etf_product': ['申万菱信中证申万医药生物指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000815',\n",
       "  'etf_name': '细分食品',\n",
       "  'etf_product': ['华宝中证细分食品饮料产业主题ETF', '华夏中证细分食品饮料产业主题ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000819',\n",
       "  'etf_name': '有色金属',\n",
       "  'etf_product': ['南方中证申万有色金属ETF', '南方有色金属联接A', '南方有色金属联接C', '南方有色金属联接E'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000824',\n",
       "  'etf_name': '国企红利',\n",
       "  'etf_product': ['西部利得中证国有企业红利指数增强A', '西部利得中证国有企业红利指数增强C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000832',\n",
       "  'etf_name': '中证转债',\n",
       "  'etf_product': ['东吴中证可转债指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000827',\n",
       "  'etf_name': '中证环保',\n",
       "  'etf_product': ['广发中证环保产业ETF',\n",
       "   '广发中证环保ETF联接基金A',\n",
       "   '广发中证环保ETF联接基金C',\n",
       "   '中证环保指数(LOF)A',\n",
       "   '中证环保指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000846',\n",
       "  'etf_name': 'ESG 100',\n",
       "  'etf_product': ['中证财通可持续发展100指数A', '中证财通可持续发展100指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000841',\n",
       "  'etf_name': '800医药',\n",
       "  'etf_product': ['中信保诚中证800医药指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399965',\n",
       "  'etf_name': '800地产',\n",
       "  'etf_product': ['鹏华中证800地产指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399966',\n",
       "  'etf_name': '800证保',\n",
       "  'etf_product': ['鹏华中证800证券保险指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30031',\n",
       "  'etf_name': '800有色',\n",
       "  'etf_product': ['中信保诚中证800有色指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H11077',\n",
       "  'etf_name': '10年国债',\n",
       "  'etf_product': ['上证10年期国债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30089',\n",
       "  'etf_name': '红利潜力',\n",
       "  'etf_product': ['建信中证红利潜力指数A', '建信中证红利潜力指数C', '山西证券中证红利潜力ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30094',\n",
       "  'etf_name': '消费红利',\n",
       "  'etf_product': ['方正富邦消费红利指数增强(LOF)', '泰达消费红利指数A', '泰达消费红利指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399975',\n",
       "  'etf_name': '证券公司',\n",
       "  'etf_product': ['国泰中证全指证券公司ETF',\n",
       "   '华宝中证全指证券公司ETF',\n",
       "   '南方全指证券联接A',\n",
       "   '南方全指证券联接C',\n",
       "   '南方中证全指证券公司ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30165',\n",
       "  'etf_name': '房地产',\n",
       "  'etf_product': ['南方中证全指房地产ETF',\n",
       "   '南方房地产联接A',\n",
       "   '南方房地产联接C',\n",
       "   '华夏中证全指房地产ETF',\n",
       "   '华夏中证全指房地产ETF联接A'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30184',\n",
       "  'etf_name': '半导体',\n",
       "  'etf_product': ['国联安中证全指半导体ETF', '国联安中证全指半导体ETF联接A', '国联安中证全指半导体ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931008',\n",
       "  'etf_name': '汽车指数',\n",
       "  'etf_product': ['广发中证全指汽车指数A', '广发中证全指汽车指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H11098',\n",
       "  'etf_name': '沪城投债',\n",
       "  'etf_product': ['海富通上证城投债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399967',\n",
       "  'etf_name': '中证军工',\n",
       "  'etf_product': ['前海开源中证军工指数A',\n",
       "   '前海开源中证军工指数C',\n",
       "   '国泰中证军工ETF',\n",
       "   '华宝中证军工ETF',\n",
       "   '广发中证军工ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H50040',\n",
       "  'etf_name': '上红低波',\n",
       "  'etf_product': ['兴业上证红利低波动ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399973',\n",
       "  'etf_name': '中证国防',\n",
       "  'etf_product': ['鹏华中证国防ETF', '鹏华中证国防指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399970',\n",
       "  'etf_name': '移动互联',\n",
       "  'etf_product': ['富国中证移动互联网指数', '鹏华中证移动互联网指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399812',\n",
       "  'etf_name': '养老产业',\n",
       "  'etf_product': ['广发养老指数A', '广发养老指数C', '国寿安保中证养老产业指数增强'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30344',\n",
       "  'etf_name': '健康产业',\n",
       "  'etf_product': ['前海开源中证健康产业指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30359',\n",
       "  'etf_name': '转型成长',\n",
       "  'etf_product': ['浙商汇金中证转型成长指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399806',\n",
       "  'etf_name': '环境治理',\n",
       "  'etf_product': ['交银施罗德中证环境治理(LOF)',\n",
       "   '汇添富中证环境治理指数(LOF)A',\n",
       "   '汇添富中证环境治理指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30372',\n",
       "  'etf_name': '中证安全',\n",
       "  'etf_product': ['东海中证社会发展安全产业主题'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399974',\n",
       "  'etf_name': '国企改革',\n",
       "  'etf_product': ['南方中证国有企业改革指数(LOF)A',\n",
       "   '南方中证国有企业改革指数(LOF)C',\n",
       "   '富国中证国有企业改革指数',\n",
       "   '易方达中证国企改革指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399989',\n",
       "  'etf_name': '中证医疗',\n",
       "  'etf_product': ['华宝中证医疗ETF',\n",
       "   '广发中证医疗指数(LOF)A',\n",
       "   '广发中证医疗指数(LOF)C',\n",
       "   '国泰中证医疗交易型开放式指数ETF',\n",
       "   '华宝中证医疗指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399976',\n",
       "  'etf_name': 'CS新能车',\n",
       "  'etf_product': ['华夏中证新能源汽车ETF',\n",
       "   '国泰中证新能源汽车ETF',\n",
       "   '国泰中证新能源汽车ETF联接A',\n",
       "   '国泰中证新能源汽车ETF联接C',\n",
       "   '博时新能源汽车ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399987',\n",
       "  'etf_name': '中证酒',\n",
       "  'etf_product': ['鹏华中证酒ETF', '鹏华中证酒指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30533',\n",
       "  'etf_name': '中国互联网50',\n",
       "  'etf_product': ['易方达中证海外中国互联网50ETF',\n",
       "   '易方达中证海外联接人民币A',\n",
       "   '易方达中证海外联接美元A',\n",
       "   '易方达中证海外联接人民币C',\n",
       "   '易方达中证海外联接美元C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399990',\n",
       "  'etf_name': '煤炭等权',\n",
       "  'etf_product': ['招商中证煤炭等权指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399997',\n",
       "  'etf_name': '中证白酒',\n",
       "  'etf_product': ['招商中证白酒指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30537',\n",
       "  'etf_name': '淘金100',\n",
       "  'etf_product': ['博时中证淘金大数据100A', '博时中证淘金大数据100I'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30588',\n",
       "  'etf_name': '中证证保',\n",
       "  'etf_product': ['天弘中证证券保险指数A', '天弘中证证券保险指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399804',\n",
       "  'etf_name': '中证体育',\n",
       "  'etf_product': ['富国中证体育产业指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399803',\n",
       "  'etf_name': '工业4.0',\n",
       "  'etf_product': ['富国中证工业4.0指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399809',\n",
       "  'etf_name': '保险主题',\n",
       "  'etf_product': ['方正富邦中证保险主题指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399998',\n",
       "  'etf_name': '中证煤炭',\n",
       "  'etf_product': ['国泰中证煤炭ETF',\n",
       "   '国泰中证煤炭ETF联接A',\n",
       "   '国泰中证煤炭ETF联接C',\n",
       "   '中融中证煤炭指数',\n",
       "   '富国中证煤炭指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H50069',\n",
       "  'etf_name': '港股通',\n",
       "  'etf_product': ['招商上证港股通ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930620',\n",
       "  'etf_name': 'CSSW丝路',\n",
       "  'etf_product': ['长盛中证申万一带一路主题指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399993',\n",
       "  'etf_name': 'CSWD生科',\n",
       "  'etf_product': ['易方达中证万得生物科技指数(LOF)A', '易方达中证万得生物科技指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930641',\n",
       "  'etf_name': '中证中药',\n",
       "  'etf_product': ['汇添富中证中药指数(LOF)A', '汇添富中证中药指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930653',\n",
       "  'etf_name': 'CS食品饮',\n",
       "  'etf_product': ['天弘中证食品饮料指数A', '天弘中证食品饮料指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930697',\n",
       "  'etf_name': '家用电器',\n",
       "  'etf_product': ['广发中证全指家用电器指数A',\n",
       "   '广发中证全指家用电器指数C',\n",
       "   '国泰中证全指家用电器ETF',\n",
       "   '国泰中证全指家用电器ETF联接A',\n",
       "   '国泰中证全指家用电器ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930701',\n",
       "  'etf_name': 'CS京津冀',\n",
       "  'etf_product': ['工银京津冀指数A',\n",
       "   '广发中证京津冀ETF联接A',\n",
       "   '广发中证京津冀ETF联接C',\n",
       "   '广发中证京津冀ETF',\n",
       "   '工银京津冀指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000016',\n",
       "  'etf_name': '上证50',\n",
       "  'etf_product': ['华夏上证50ETF',\n",
       "   '易方达上证50指数A',\n",
       "   '中海上证50指数增强',\n",
       "   '万家上证50ETF',\n",
       "   '华夏上证50ETF联接A'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000903',\n",
       "  'etf_name': '中证100',\n",
       "  'etf_product': ['长盛中证100指数',\n",
       "   '中银中证100指数增强',\n",
       "   '华宝中证100指数A',\n",
       "   '海富通中证100指数(LOF)A',\n",
       "   '诺安中证100指数A'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000904',\n",
       "  'etf_name': '中证200',\n",
       "  'etf_product': ['泰信中证200指数基金', '民生加银中证200指数增强A', '民生加银中证200指数增强C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000906',\n",
       "  'etf_name': '中证800',\n",
       "  'etf_product': ['长盛同庆中证800(LOF)',\n",
       "   '天弘中证800指数A',\n",
       "   '天弘中证800指数C',\n",
       "   '添富中证800ETF',\n",
       "   '易方达中证800ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000913',\n",
       "  'etf_name': '300医药',\n",
       "  'etf_product': ['易方达沪深300医药ETF', '易方达沪深300医药卫生ETF联接A', '易方达沪深300医药卫生ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000018',\n",
       "  'etf_name': '180金融',\n",
       "  'etf_product': ['国泰上证180金融ETF', '国泰上证180金融ETF联接', '兴业上证180金融ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H11001',\n",
       "  'etf_name': '中证全债',\n",
       "  'etf_product': ['湘财长源股票型A', '湘财长源股票型C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000922',\n",
       "  'etf_name': '中证红利',\n",
       "  'etf_product': ['富国中证红利指数增强A',\n",
       "   '大成中证红利指数A',\n",
       "   '万家中证红利指数(LOF)',\n",
       "   '大成中证红利指数C',\n",
       "   '招商中证红利ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000021',\n",
       "  'etf_name': '180治理',\n",
       "  'etf_product': ['交银上证180公司治理ETF', '交银上证180公司治理ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000036',\n",
       "  'etf_name': '上证消费',\n",
       "  'etf_product': ['华夏消费ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000038',\n",
       "  'etf_name': '上证金融',\n",
       "  'etf_product': ['华夏金融ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000043',\n",
       "  'etf_name': '超大盘',\n",
       "  'etf_product': ['博时上证超大盘ETF', '博时上证超大盘ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000044',\n",
       "  'etf_name': '上证中盘',\n",
       "  'etf_product': ['易方达上证中盘ETF', '易方达上证中盘ETF联接A', '易方达上证中盘ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000928',\n",
       "  'etf_name': '中证能源',\n",
       "  'etf_product': ['汇添富中证能源ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000932',\n",
       "  'etf_name': '中证消费',\n",
       "  'etf_product': ['汇添富中证主要消费ETF',\n",
       "   '嘉实中证主要消费ETF',\n",
       "   '汇添富中证主要消费ETF联接',\n",
       "   '嘉实中证主要消费ETF联接A',\n",
       "   '嘉实中证主要消费ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000934',\n",
       "  'etf_name': '中证金融',\n",
       "  'etf_product': ['汇添富中证金融地产ETF',\n",
       "   '嘉实中证金融地产ETF',\n",
       "   '嘉实中证金融地产ETF联接A',\n",
       "   '嘉实中证金融地产ETF联接C',\n",
       "   '长盛中证金融地产指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000048',\n",
       "  'etf_name': '责任指数',\n",
       "  'etf_product': ['建信上证社会责任ETF', '建信上证社会责任ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000063',\n",
       "  'etf_name': '上证周期',\n",
       "  'etf_product': ['海富通上证周期ETF', '海富通上证周期ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000064',\n",
       "  'etf_name': '非周期',\n",
       "  'etf_product': ['海富通上证非周期ETF', '海富通上证非周期ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000065',\n",
       "  'etf_name': '上证龙头',\n",
       "  'etf_product': ['华安上证龙头ETF', '华安上证龙头ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000964',\n",
       "  'etf_name': '中证新兴',\n",
       "  'etf_product': ['东吴中证新兴'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000068',\n",
       "  'etf_name': '上证资源',\n",
       "  'etf_product': ['博时上证自然资源ETF', '博时上证自然资源ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000069',\n",
       "  'etf_name': '消费80',\n",
       "  'etf_product': ['招商上证消费80ETF', '招商上证消费80ETF联接A', '招商上证消费80ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000966',\n",
       "  'etf_name': '基本400',\n",
       "  'etf_product': ['浦银安盛基本面400指数', '泰信中证锐联基本面400指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H11017',\n",
       "  'etf_name': '中期国债',\n",
       "  'etf_product': ['嘉实中证金边中期国债ETF联接A', '嘉实中证金边中期国债ETF联接C', '嘉实中证中期国债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000982',\n",
       "  'etf_name': '500等权',\n",
       "  'etf_product': ['前海开源中证500等权ETF', '招商中证500等权重指数增强A', '招商中证500等权重指数增强C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000987',\n",
       "  'etf_name': '全指材料',\n",
       "  'etf_product': ['广发中证全指原材料ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000989',\n",
       "  'etf_name': '全指可选',\n",
       "  'etf_product': ['广发中证全指可选消费ETF', '广发中证全指可选消费ETF联接A', '广发中证全指可选消费ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000992',\n",
       "  'etf_name': '全指金融',\n",
       "  'etf_product': ['广发中证全指金融地产ETF', '广发中证全指金融地产ETF联接A', '广发中证全指金融地产ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000979',\n",
       "  'etf_name': '大宗商品',\n",
       "  'etf_product': ['招商中证商品指数基金(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000806',\n",
       "  'etf_name': '消费服务',\n",
       "  'etf_product': ['上投摩根中证消费服务指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000814',\n",
       "  'etf_name': '细分医药',\n",
       "  'etf_product': ['华安中证医药ETF', '华安中证细分医药交易A', '华安中证细分医药交易C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000821',\n",
       "  'etf_name': '300红利',\n",
       "  'etf_product': ['建信沪深300红利ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000828',\n",
       "  'etf_name': '300高贝',\n",
       "  'etf_product': ['招商沪深300高贝塔指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399802',\n",
       "  'etf_name': '500深市',\n",
       "  'etf_product': ['大成中证500深市ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H00140',\n",
       "  'etf_name': '5年国债',\n",
       "  'etf_product': ['国泰上证5年期国债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30035',\n",
       "  'etf_name': '300非银',\n",
       "  'etf_product': ['易方达沪深300非银ETF', '易方达沪深300非银行金融交易A', '易方达沪深300非银行金融交易C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30124',\n",
       "  'etf_name': '安中动态',\n",
       "  'etf_product': ['汇添富沪深300安中指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399986',\n",
       "  'etf_name': '中证银行',\n",
       "  'etf_product': ['富国中证银行指数', '南方中证银行ETF', '南方银行联接A', '南方银行联接C', '华宝中证银行ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931009',\n",
       "  'etf_name': '建筑材料',\n",
       "  'etf_product': ['广发中证全指建筑材料指数A', '广发中证全指建筑材料指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931160',\n",
       "  'etf_name': '通信设备',\n",
       "  'etf_product': ['国泰中证全指通信设备ETF', '国泰中证全指通信设备交易联接A', '国泰中证全指通信设备交易联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30257',\n",
       "  'etf_name': '500信息',\n",
       "  'etf_product': ['中证500信息技术指数ETF', '南方中证500信息技术ETF联接A', '南方中证500信息技术ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30263',\n",
       "  'etf_name': '腾讯济安',\n",
       "  'etf_product': ['定投宝'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399983',\n",
       "  'etf_name': '地产等权',\n",
       "  'etf_product': ['招商沪深300地产等权重指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30269',\n",
       "  'etf_name': '红利低波',\n",
       "  'etf_product': ['创金合信中证红利低波动指数A',\n",
       "   '创金合信中证红利低波动指数C',\n",
       "   '华泰柏瑞中证红利低波动ETF',\n",
       "   '华泰柏瑞中证红利低波ETF联接A',\n",
       "   '华泰柏瑞中证红利低波ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399971',\n",
       "  'etf_name': '中证传媒',\n",
       "  'etf_product': ['广发中证传媒ETF',\n",
       "   '广发中证传媒ETF联接A',\n",
       "   '广发中证传媒ETF联接C',\n",
       "   '鹏华中证传媒ETF',\n",
       "   '工银传媒指数A'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30318',\n",
       "  'etf_name': '科技传媒通信150',\n",
       "  'etf_product': ['景顺长城中证科技传媒通信150ETF', '景顺长城中证科技传媒通信150ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H11018',\n",
       "  'etf_name': '沪质城投',\n",
       "  'etf_product': ['海富通上证城投债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399814',\n",
       "  'etf_name': '大农业',\n",
       "  'etf_product': ['前海开源中证大农业指数增强'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30373',\n",
       "  'etf_name': '百发100',\n",
       "  'etf_product': ['广发百发100指数A', '广发百发100指数E'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399996',\n",
       "  'etf_name': '智能家居',\n",
       "  'etf_product': ['中信保诚中证智能家居指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000852',\n",
       "  'etf_name': '中证1000',\n",
       "  'etf_product': ['南方中证1000ETF',\n",
       "   '创金合信中证1000指数增强A',\n",
       "   '创金合信中证1000指数增强C',\n",
       "   '招商中证1000指数A',\n",
       "   '招商中证1000指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30531',\n",
       "  'etf_name': '精工制造',\n",
       "  'etf_product': ['建信精工制造指数增强'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': 'H30535',\n",
       "  'etf_name': '互联网',\n",
       "  'etf_product': ['南方中证互联网指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399807',\n",
       "  'etf_name': '高铁产业',\n",
       "  'etf_product': ['南方中证高铁产业指数(LOF)', '鹏华中证高铁产业指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399991',\n",
       "  'etf_name': '一带一路',\n",
       "  'etf_product': ['鹏华中证一带一路主题指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399994',\n",
       "  'etf_name': '信息安全',\n",
       "  'etf_product': ['中信保诚中证信息安全指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399995',\n",
       "  'etf_name': '基建工程',\n",
       "  'etf_product': ['信诚中证基建工程指数(LOF)', '广发中证基建工程指数A', '广发中证基建工程指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930606',\n",
       "  'etf_name': '中证钢铁',\n",
       "  'etf_product': ['国泰中证钢铁ETF', '国泰中证钢铁ETF联接A', '国泰中证钢铁ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399707',\n",
       "  'etf_name': 'CSSW证券',\n",
       "  'etf_product': ['国泰中证申万证券行业指数(LOF)', '申万菱信中证申万证券行业指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399992',\n",
       "  'etf_name': 'CSWD并购',\n",
       "  'etf_product': ['易方达中证万得并购重组指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930648',\n",
       "  'etf_name': 'CS智消费',\n",
       "  'etf_product': ['博时中证智能消费ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930651',\n",
       "  'etf_name': 'CS计算机',\n",
       "  'etf_product': ['国泰中证计算机主题ETF',\n",
       "   '天弘中证计算机主题ETF',\n",
       "   '天弘中证计算机主题ETF联接A',\n",
       "   '天弘中证计算机主题ETF联接C',\n",
       "   '国泰中证计算机主题ETF联接A'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930652',\n",
       "  'etf_name': 'CS电子',\n",
       "  'etf_product': ['天弘中证电子ETF', '天弘中证电子ETF联接A', '天弘中证电子ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930703',\n",
       "  'etf_name': '福建50',\n",
       "  'etf_product': ['兴业中证福建50ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930713',\n",
       "  'etf_name': 'CS人工智',\n",
       "  'etf_product': ['融通人工智能指数(LOF)A',\n",
       "   '平安人工智能ETF',\n",
       "   '华夏中证人工智能主题ETF',\n",
       "   '融通人工智能指数(LOF)C',\n",
       "   '华夏中证人工智能主题ETF联接A'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '399811',\n",
       "  'etf_name': 'CSSW电子',\n",
       "  'etf_product': ['申万菱信中证申万电子行业投资指数(LOF)A', '申万菱信中证申万电子行业投资指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930719',\n",
       "  'etf_name': 'CS精准医',\n",
       "  'etf_product': ['汇添富中证精准医指数A(LOF)', '汇添富中证精准医指数C(LOF)', '融通中证精准医疗主题指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930720',\n",
       "  'etf_name': 'CS互医疗',\n",
       "  'etf_product': ['汇添富中证互联网医疗指数(LOF)A', '汇添富中证互联网医疗指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930721',\n",
       "  'etf_name': 'CS智汽车',\n",
       "  'etf_product': ['富国中证智能汽车指数(LOF)',\n",
       "   '富国中证智能汽车主题ETF',\n",
       "   '天弘中证智能汽车A',\n",
       "   '天弘中证智能汽车C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930723',\n",
       "  'etf_name': '沪港深F100',\n",
       "  'etf_product': ['浦银沪港深基本面'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930726',\n",
       "  'etf_name': 'CS生医',\n",
       "  'etf_product': ['国泰中证生物医药ETF', '国泰中证生物医药ETF联接A', '国泰中证生物医药ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930734',\n",
       "  'etf_name': '360互联+',\n",
       "  'etf_product': ['大成中证360A', '大成中证360C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930729',\n",
       "  'etf_name': '银智100',\n",
       "  'etf_product': ['博时银智大数据100A', '博时银智大数据100C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930743',\n",
       "  'etf_name': '中证生科',\n",
       "  'etf_product': ['汇添富中证生物科技指数(LOF)A', '汇添富中证生物科技指数(LOF)C', '易方达中证生物科技主题ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '950090',\n",
       "  'etf_name': '上证50优选',\n",
       "  'etf_product': ['华夏上证50AH优选指数(LOF)A', '华夏上证50AH优选指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930780',\n",
       "  'etf_name': '中证兴业中高债',\n",
       "  'etf_product': ['中证兴业中高等级信用债指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930782',\n",
       "  'etf_name': '500SNLV',\n",
       "  'etf_product': ['景顺长城中证500行业中性低波动指数',\n",
       "   '华安中证500低波ETF',\n",
       "   '华安中证500低波ETF联接A',\n",
       "   '华安中证500低波ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930784',\n",
       "  'etf_name': 'HK红利EW',\n",
       "  'etf_product': ['财通中证香港红利等权投资指数A', '财通中证香港红利等权投资指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930790',\n",
       "  'etf_name': 'CS娱乐TI',\n",
       "  'etf_product': ['富国中证娱乐主题指数增强型(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930791',\n",
       "  'etf_name': 'CS医药TI',\n",
       "  'etf_product': ['富国中证医药主题指数增强(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930792',\n",
       "  'etf_name': 'HK银行',\n",
       "  'etf_product': ['泰康香港银行指数A', '泰康香港银行指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930794',\n",
       "  'etf_name': '中美互联网',\n",
       "  'etf_product': ['天弘中证中美互联网指数(QDII)A', '天弘中证中美互联网指数(QDII)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930820',\n",
       "  'etf_name': 'CS高端制',\n",
       "  'etf_product': ['富国中证高端制造指数增强型(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '950096',\n",
       "  'etf_name': '上海国企',\n",
       "  'etf_product': ['中证上海国企ETF', '中证上海国企ETF联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930836',\n",
       "  'etf_name': '沪港深高股息',\n",
       "  'etf_product': ['信达澳银中证沪港深高股息精选'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930838',\n",
       "  'etf_name': 'CS高股息',\n",
       "  'etf_product': ['浦银安盛中证高股息ETF', '浦银安盛中证高股息ETF联接A', '浦银安盛中证高股息ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930839',\n",
       "  'etf_name': 'HK高股息',\n",
       "  'etf_product': ['民生加银中证港股通高股息精选A', '民生加银中证港股通高股息精选C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930846',\n",
       "  'etf_name': '300SNLV',\n",
       "  'etf_product': ['华安沪深300行业中性低波动ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930865',\n",
       "  'etf_name': '5年地债',\n",
       "  'etf_product': ['鹏华中证5年地债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930851',\n",
       "  'etf_name': '云计算',\n",
       "  'etf_product': ['融通中证云计算与大数据主题指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930874',\n",
       "  'etf_name': '政金债8-10',\n",
       "  'etf_product': ['建信中证政策性金融债8-10年指数(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930875',\n",
       "  'etf_name': '空天军工',\n",
       "  'etf_product': ['鹏华空天一体A(LOF)', '鹏华空天一体C(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930902',\n",
       "  'etf_name': '中证数据',\n",
       "  'etf_product': ['富国中证大数据产业ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '950105',\n",
       "  'etf_name': '上证证券',\n",
       "  'etf_product': ['汇安上证证券ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '950109',\n",
       "  'etf_name': '上证10年地债',\n",
       "  'etf_product': ['上证10年期地方政府债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930914',\n",
       "  'etf_name': '港股通高股息',\n",
       "  'etf_product': ['汇添富中证港股通高股息投资指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930916',\n",
       "  'etf_name': '中证10年国债',\n",
       "  'etf_product': ['富国中证10年期国债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930917',\n",
       "  'etf_name': 'SHS高股息',\n",
       "  'etf_product': ['银河中证沪港深高股息指数A(LOF)', '银河中证沪港深高股息指数C(LOF)'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000171',\n",
       "  'etf_name': '新兴成指',\n",
       "  'etf_product': ['华夏战略新兴成指ETF', '华夏战略新兴成指ETF联接A', '华夏战略新兴成指ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '950113',\n",
       "  'etf_name': '沪质中高债3-5',\n",
       "  'etf_product': ['华夏3-5年中高级可质押信用债ETF',\n",
       "   '华夏3-5年中高级可质押信用债ETF联接A',\n",
       "   '华夏3-5年中高级可质押信用债ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930949',\n",
       "  'etf_name': '价值回报',\n",
       "  'etf_product': ['中邮中证价值回报量化策略指数A', '中邮中证价值回报量化策略指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930954',\n",
       "  'etf_name': '5年久期国开债',\n",
       "  'etf_product': ['华富中证5年恒定久期国开债指数A', '华富中证5年恒定久期国开债指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930955',\n",
       "  'etf_name': '红利低波100',\n",
       "  'etf_product': ['天弘中证红利低波动100A', '天弘中证红利低波动100C', '景顺长城中证红利低波动100ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930997',\n",
       "  'etf_name': '新能源车',\n",
       "  'etf_product': ['汇添富中证新能源汽车产业指数(LOF)A',\n",
       "   '汇添富中证新能源汽车产业指数(LOF)C',\n",
       "   '平安中证新能源汽车产业ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930999',\n",
       "  'etf_name': 'SHS大湾区',\n",
       "  'etf_product': ['建信中证沪港深粤港澳大湾区发展主题ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931000',\n",
       "  'etf_name': '大湾区',\n",
       "  'etf_product': ['粤港澳大湾区ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931018',\n",
       "  'etf_name': '中证5-10年国债活跃券',\n",
       "  'etf_product': ['平安中证5-10年期国债活跃券ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931024',\n",
       "  'etf_name': 'HKC非银',\n",
       "  'etf_product': ['泰康中证港股通非银指数A', '泰康中证港股通非银指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931033',\n",
       "  'etf_name': '杭州湾区',\n",
       "  'etf_product': ['南华中证杭州湾区交易ETF', '南华中证杭州湾区ETF联接A', '南华中证杭州湾区ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931052',\n",
       "  'etf_name': '国信价值',\n",
       "  'etf_product': ['富国中证价值ETF', '富国中证价值ETF联接A', '富国中证价值ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931062',\n",
       "  'etf_name': '质量低波',\n",
       "  'etf_product': ['恒生前海中证质量成长A', '恒生前海中证质量成长C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931066',\n",
       "  'etf_name': '军工龙头',\n",
       "  'etf_product': ['富国中证军工龙头ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931069',\n",
       "  'etf_name': '中金300',\n",
       "  'etf_product': ['中金中证优选300指数(LOF)A', '中金中证优选300指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931067',\n",
       "  'etf_name': '绩优策略',\n",
       "  'etf_product': ['泰达宏利中证绩优指数A', '泰达宏利中证绩优指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000860',\n",
       "  'etf_name': '结构调整',\n",
       "  'etf_product': ['博时央企结构调整ETF',\n",
       "   '华夏中证央企ETF',\n",
       "   '银华中证央企ETF',\n",
       "   '华夏中证央企ETF联接A',\n",
       "   '华夏中证央企ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930738',\n",
       "  'etf_name': '四川国改',\n",
       "  'etf_product': ['华夏中证四川国改ETF', '华夏中证四川国改发起式ETF联接A', '华夏中证四川国改发起式ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931071',\n",
       "  'etf_name': '人工智能',\n",
       "  'etf_product': ['华富中证人工智能产业ETF', '华富中证人工智能产业ETF联接A', '华富中证人工智能产业ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930939',\n",
       "  'etf_name': '500质量',\n",
       "  'etf_product': ['鹏扬中证500质量成长指数A', '鹏扬中证500质量成长指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931068',\n",
       "  'etf_name': '消费龙头',\n",
       "  'etf_product': ['华宝中证消费龙头指数(LOF)A', '华宝中证消费龙头指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930758',\n",
       "  'etf_name': '凤凰50',\n",
       "  'etf_product': ['浙商汇金中证浙江凤凰行动50ETF', '浙商之江凤凰联接'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '930740',\n",
       "  'etf_name': '300 红利LV',\n",
       "  'etf_product': ['嘉实沪深300红利低波动ETF',\n",
       "   '嘉实沪深300红利低波动ETF联接A',\n",
       "   '嘉实沪深300红利低波动ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931127',\n",
       "  'etf_name': '浙江新动能',\n",
       "  'etf_product': ['易方达中证浙江新动能ETF(QDII)',\n",
       "   '易方达中证新动能ETF联接(QDII)A',\n",
       "   '易方达中证新动能ETF联接(QDII)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931136',\n",
       "  'etf_name': '深圳科技',\n",
       "  'etf_product': ['安信深圳科技指数(LOF)A', '安信深圳科技指数(LOF)C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931078',\n",
       "  'etf_name': '中证转债及可交换债',\n",
       "  'etf_product': ['中泰中证可转债及可交债指数A', '中泰中证可转债及可交债指数C', '博时中证可转债及可交换债券ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '950045',\n",
       "  'etf_name': '上证5年期地债',\n",
       "  'etf_product': ['海富通上证5年期地方政府债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931134',\n",
       "  'etf_name': 'AH经济蓝筹',\n",
       "  'etf_product': ['华夏中证AH经济蓝筹股票指数A', '华夏中证AH经济蓝筹股票指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931142',\n",
       "  'etf_name': '东证竞争',\n",
       "  'etf_product': ['东方红中证竞争力指数A', '东方红中证竞争力指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931087',\n",
       "  'etf_name': '科技龙头',\n",
       "  'etf_product': ['华宝中证科技龙头ETF', '华宝科技ETF联接A', '华宝科技ETF联接C', '工银瑞信中证科技龙头ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931139',\n",
       "  'etf_name': 'CS消费50',\n",
       "  'etf_product': ['富国中证消费50ETF',\n",
       "   '富国中证消费50ETF联接A',\n",
       "   '富国中证消费50ETF联接C',\n",
       "   '东兴中证消费50指数A',\n",
       "   '东兴中证消费50指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931140',\n",
       "  'etf_name': '医药50',\n",
       "  'etf_product': ['富国中证医药50ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931141',\n",
       "  'etf_name': 'CS长三角',\n",
       "  'etf_product': ['添富中证长三角ETF', '汇添富中证长三角ETF联接A', '汇添富中证长三角ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931151',\n",
       "  'etf_name': '光伏产业',\n",
       "  'etf_product': ['华泰柏瑞中证光伏产业ETF', '银华中证光伏产业ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931152',\n",
       "  'etf_name': 'CS创新药',\n",
       "  'etf_product': ['银华中证创新药产业ETF', '广发中证创新药产业ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '950041',\n",
       "  'etf_name': '上证投资级转债及可交换债',\n",
       "  'etf_product': ['海富通上证投资级可转债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '950047',\n",
       "  'etf_name': '上证1-5年地债',\n",
       "  'etf_product': ['兴业上证1-5年期地方政府债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931161',\n",
       "  'etf_name': '0-4年地债',\n",
       "  'etf_product': ['鹏华中证0-4年期地方政府债ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931162',\n",
       "  'etf_name': '中证转债及可交换债50',\n",
       "  'etf_product': ['长信中证转债及可交换债50指数A', '长信中证转债及可交换债50指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931079',\n",
       "  'etf_name': '5G通信',\n",
       "  'etf_product': ['华夏中证5G通信主题ETF',\n",
       "   '华夏中证5G通信主题ETF联接A',\n",
       "   '华夏中证5G通信主题ETF联接C',\n",
       "   '银华中证5GETF',\n",
       "   '银华中证5G通信主题ETF联接A'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931157',\n",
       "  'etf_name': 'SHS红利成长LV',\n",
       "  'etf_product': ['景顺沪港深红利成长低波动指数A', '景顺沪港深红利成长低波动指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931165',\n",
       "  'etf_name': '新兴科技100',\n",
       "  'etf_product': ['嘉实中证新兴科技100ETF', '嘉实新兴科技100ETF联接A', '嘉实新兴科技100ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931166',\n",
       "  'etf_name': '医药健康100',\n",
       "  'etf_product': ['嘉实医药健康100ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931167',\n",
       "  'etf_name': '先进制造100',\n",
       "  'etf_product': ['嘉实先进制造100ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931163',\n",
       "  'etf_name': '浙江100',\n",
       "  'etf_product': ['招商中证浙江100ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000859',\n",
       "  'etf_name': '国企一带一路',\n",
       "  'etf_product': ['易方达中证国企一带一路ETF',\n",
       "   '富国中证国企一带一路ETF',\n",
       "   '添富中证国企一带一路ETF',\n",
       "   '富国中证国企一带一路ETF联接A',\n",
       "   '富国中证国企一带一路ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000861',\n",
       "  'etf_name': '央企创新',\n",
       "  'etf_product': ['富国央企创新ETF',\n",
       "   '博时央企创新驱动ETF',\n",
       "   '广发中证央企创新驱动ETF',\n",
       "   '嘉实中证央企创新驱动ETF',\n",
       "   '广发央企创新驱动ETF联接A'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931159',\n",
       "  'etf_name': '创新100',\n",
       "  'etf_product': ['诺德研发创新100',\n",
       "   '申万菱信中证研发创新100ETF',\n",
       "   '申万菱信中证研发创新100ETF联接A',\n",
       "   '申万菱信中证研发创新100ETF联接C',\n",
       "   '银华中证研发创新100ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931186',\n",
       "  'etf_name': '中证科技',\n",
       "  'etf_product': ['富国中证科技50策略ETF', '富国中证科技50策略ETF联接A', '富国中证科技50策略ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931144',\n",
       "  'etf_name': '通信技术',\n",
       "  'etf_product': ['东财通信A', '东财通信C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931187',\n",
       "  'etf_name': '科技100',\n",
       "  'etf_product': ['华泰柏瑞中证科技100ETF',\n",
       "   '华泰柏瑞中证科技ETF联接A',\n",
       "   '华泰柏瑞中证科技ETF联接C',\n",
       "   '天弘中证科技100指数增强A',\n",
       "   '天弘中证科技100指数增强C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931175',\n",
       "  'etf_name': '银行50金融债',\n",
       "  'etf_product': ['兴业中证银行50金融债指数A', '兴业中证银行50金融债指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931172',\n",
       "  'etf_name': '信用主体50',\n",
       "  'etf_product': ['安信信用主体50债券指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931268',\n",
       "  'etf_name': '持续发展',\n",
       "  'etf_product': ['博时可持续发展100ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931373',\n",
       "  'etf_name': '股息龙头',\n",
       "  'etf_product': ['鹏华中证高股息龙头ETF', '鹏华股息龙头ETF联接A', '鹏华股息龙头ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931357',\n",
       "  'etf_name': '优选消费50',\n",
       "  'etf_product': ['中金中证沪港深优选消费50指数A', '中金中证沪港深优选消费50指数C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931306',\n",
       "  'etf_name': '国债及政金债1-5',\n",
       "  'etf_product': ['农银中证国债及政金债1-5年指数'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931381',\n",
       "  'etf_name': '中证长三角',\n",
       "  'etf_product': ['海富通中证长三角领先ETF联接', '海富通中证长三角领先ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931380',\n",
       "  'etf_name': '科技50',\n",
       "  'etf_product': ['易方达中证科技50ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931372',\n",
       "  'etf_name': '浙江国资',\n",
       "  'etf_product': ['华夏中证浙江国资创新发展ETF',\n",
       "   '华夏中证浙江国资创新发展ETF联接A',\n",
       "   '华夏中证浙江国资创新发展ETF联接C'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '931406',\n",
       "  'etf_name': '5G 50',\n",
       "  'etf_product': ['博时中证5G产业50ETF'],\n",
       "  'crawltime': '2021-01-24'},\n",
       " {'etf_code': '000688',\n",
       "  'etf_name': '科创50',\n",
       "  'etf_product': ['工银上证科创板50成份ETF',\n",
       "   '华泰柏瑞上证科创板50成份ETF',\n",
       "   '华夏上证科创板50成份ETF',\n",
       "   '易方达上证科创板50成份ETF'],\n",
       "  'crawltime': '2021-01-24'}]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "product_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "code_list = list(map(lambda x:x.get('etf_code'),product_list))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['000001',\n",
       " '000010',\n",
       " '000012',\n",
       " '000015',\n",
       " '000300',\n",
       " '000905',\n",
       " '000914',\n",
       " '000919',\n",
       " 'H11014',\n",
       " '000029',\n",
       " '000037',\n",
       " '000925',\n",
       " '000042',\n",
       " '000046',\n",
       " '000933',\n",
       " '000935',\n",
       " '931461',\n",
       " '000944',\n",
       " '000949',\n",
       " '000056',\n",
       " '000901',\n",
       " '000961',\n",
       " '000963',\n",
       " '000066',\n",
       " '399701',\n",
       " '399702',\n",
       " '000969',\n",
       " '000009',\n",
       " '000971',\n",
       " '000978',\n",
       " '000984',\n",
       " '000986',\n",
       " '000991',\n",
       " '000993',\n",
       " '399959',\n",
       " 'H11136',\n",
       " '000802',\n",
       " '000998',\n",
       " '000805',\n",
       " '000808',\n",
       " '000815',\n",
       " '000819',\n",
       " '000824',\n",
       " '000832',\n",
       " '000827',\n",
       " '000846',\n",
       " '000841',\n",
       " '399965',\n",
       " '399966',\n",
       " 'H30031',\n",
       " 'H11077',\n",
       " 'H30089',\n",
       " 'H30094',\n",
       " '399975',\n",
       " 'H30165',\n",
       " 'H30184',\n",
       " '931008',\n",
       " 'H11098',\n",
       " '399967',\n",
       " 'H50040',\n",
       " '399973',\n",
       " '399970',\n",
       " '399812',\n",
       " 'H30344',\n",
       " 'H30359',\n",
       " '399806',\n",
       " 'H30372',\n",
       " '399974',\n",
       " '399989',\n",
       " '399976',\n",
       " '399987',\n",
       " 'H30533',\n",
       " '399990',\n",
       " '399997',\n",
       " 'H30537',\n",
       " 'H30588',\n",
       " '399804',\n",
       " '399803',\n",
       " '399809',\n",
       " '399998',\n",
       " 'H50069',\n",
       " '930620',\n",
       " '399993',\n",
       " '930641',\n",
       " '930653',\n",
       " '930697',\n",
       " '930701',\n",
       " '000016',\n",
       " '000903',\n",
       " '000904',\n",
       " '000906',\n",
       " '000913',\n",
       " '000018',\n",
       " 'H11001',\n",
       " '000922',\n",
       " '000021',\n",
       " '000036',\n",
       " '000038',\n",
       " '000043',\n",
       " '000044',\n",
       " '000928',\n",
       " '000932',\n",
       " '000934',\n",
       " '000048',\n",
       " '000063',\n",
       " '000064',\n",
       " '000065',\n",
       " '000964',\n",
       " '000068',\n",
       " '000069',\n",
       " '000966',\n",
       " 'H11017',\n",
       " '000982',\n",
       " '000987',\n",
       " '000989',\n",
       " '000992',\n",
       " '000979',\n",
       " '000806',\n",
       " '000814',\n",
       " '000821',\n",
       " '000828',\n",
       " '399802',\n",
       " 'H00140',\n",
       " 'H30035',\n",
       " 'H30124',\n",
       " '399986',\n",
       " '931009',\n",
       " '931160',\n",
       " 'H30257',\n",
       " 'H30263',\n",
       " '399983',\n",
       " 'H30269',\n",
       " '399971',\n",
       " 'H30318',\n",
       " 'H11018',\n",
       " '399814',\n",
       " 'H30373',\n",
       " '399996',\n",
       " '000852',\n",
       " 'H30531',\n",
       " 'H30535',\n",
       " '399807',\n",
       " '399991',\n",
       " '399994',\n",
       " '399995',\n",
       " '930606',\n",
       " '399707',\n",
       " '399992',\n",
       " '930648',\n",
       " '930651',\n",
       " '930652',\n",
       " '930703',\n",
       " '930713',\n",
       " '399811',\n",
       " '930719',\n",
       " '930720',\n",
       " '930721',\n",
       " '930723',\n",
       " '930726',\n",
       " '930734',\n",
       " '930729',\n",
       " '930743',\n",
       " '950090',\n",
       " '930780',\n",
       " '930782',\n",
       " '930784',\n",
       " '930790',\n",
       " '930791',\n",
       " '930792',\n",
       " '930794',\n",
       " '930820',\n",
       " '950096',\n",
       " '930836',\n",
       " '930838',\n",
       " '930839',\n",
       " '930846',\n",
       " '930865',\n",
       " '930851',\n",
       " '930874',\n",
       " '930875',\n",
       " '930902',\n",
       " '950105',\n",
       " '950109',\n",
       " '930914',\n",
       " '930916',\n",
       " '930917',\n",
       " '000171',\n",
       " '950113',\n",
       " '930949',\n",
       " '930954',\n",
       " '930955',\n",
       " '930997',\n",
       " '930999',\n",
       " '931000',\n",
       " '931018',\n",
       " '931024',\n",
       " '931033',\n",
       " '931052',\n",
       " '931062',\n",
       " '931066',\n",
       " '931069',\n",
       " '931067',\n",
       " '000860',\n",
       " '930738',\n",
       " '931071',\n",
       " '930939',\n",
       " '931068',\n",
       " '930758',\n",
       " '930740',\n",
       " '931127',\n",
       " '931136',\n",
       " '931078',\n",
       " '950045',\n",
       " '931134',\n",
       " '931142',\n",
       " '931087',\n",
       " '931139',\n",
       " '931140',\n",
       " '931141',\n",
       " '931151',\n",
       " '931152',\n",
       " '950041',\n",
       " '950047',\n",
       " '931161',\n",
       " '931162',\n",
       " '931079',\n",
       " '931157',\n",
       " '931165',\n",
       " '931166',\n",
       " '931167',\n",
       " '931163',\n",
       " '000859',\n",
       " '000861',\n",
       " '931159',\n",
       " '931186',\n",
       " '931144',\n",
       " '931187',\n",
       " '931175',\n",
       " '931172',\n",
       " '931268',\n",
       " '931373',\n",
       " '931357',\n",
       " '931306',\n",
       " '931381',\n",
       " '931380',\n",
       " '931372',\n",
       " '931406',\n",
       " '000688']"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "code_list"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "etf_doc = mongo_db['fund']['etf_quanzhong']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "etf_list=[]\n",
    "for item in etf_doc.find({},{'_id':0}):\n",
    "    if item['ETF代码'] in code_list:\n",
    "        etf_list.append(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "248"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(etf_list)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'ETF代码': '000012',\n",
       " 'ETF名称': '国债指数',\n",
       " '权重': [{'代码': '019639', '名称': '20特国04', '行业': None, '权重': 2.39},\n",
       "  {'代码': '019637', '名称': '20特国03', '行业': None, '权重': 2.36},\n",
       "  {'代码': '019632', '名称': '20国债06', '行业': None, '权重': 2.29},\n",
       "  {'代码': '019634', '名称': '20国债08', '行业': None, '权重': 2.27},\n",
       "  {'代码': '019631', '名称': '20国债05', '行业': None, '权重': 2.16},\n",
       "  {'代码': '019641', '名称': '20国债11', '行业': None, '权重': 2.0},\n",
       "  {'代码': '019614', '名称': '19国债04', '行业': None, '权重': 1.97},\n",
       "  {'代码': '019643', '名称': '20国债13', '行业': None, '权重': 1.97},\n",
       "  {'代码': '019617', '名称': '19国债07', '行业': None, '权重': 1.93},\n",
       "  {'代码': '019616', '名称': '19国债06', '行业': None, '权重': 1.89}]}"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "etf_list[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "'权重'\n",
      "{'ETF代码': 'H30359', 'ETF名称': '转型成长', '权重': []}\n",
      "'权重'\n",
      "{'ETF代码': 'H30373', 'ETF名称': '百发100', '权重': []}\n",
      "'权重'\n",
      "{'ETF代码': 'H30537', 'ETF名称': '淘金100', '权重': []}\n",
      "'权重'\n",
      "{'ETF代码': '930734', 'ETF名称': '360互联+', '权重': []}\n",
      "'权重'\n",
      "{'ETF代码': '930729', 'ETF名称': '银智100', '权重': []}\n"
     ]
    }
   ],
   "source": [
    "reach_15percent=[]\n",
    "for item in etf_list:\n",
    "    qz=item['权重']\n",
    "    df =pd.DataFrame(qz)\n",
    "    try:\n",
    "        df=df.sort_values(by='权重',ascending=False)\n",
    "        if df.iloc[0]['权重']>=14:\n",
    "            reach_15percent.append(item)\n",
    "#             print(item['ETF名称'],item['ETF代码'])\n",
    "#             print('#'*20)\n",
    "    except Exception as e:\n",
    "        print(e)\n",
    "        print(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "reach_15percent_ =[]\n",
    "for item in reach_15percent:\n",
    "    item['最大的个股']=item['权重'][0]['名称']\n",
    "    item['最大的个股权重']=item['权重'][0]['权重']\n",
    "    reach_15percent_.append(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(reach_15percent_,index=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('more_than_15percent.xls',encoding='utf8',index=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "5年国债 H00140\n",
      "10年国债 H11077\n",
      "'权重'\n",
      "{'ETF代码': 'H30359', 'ETF名称': '转型成长', '权重': []}\n",
      "'权重'\n",
      "{'ETF代码': 'H30373', 'ETF名称': '百发100', '权重': []}\n",
      "中国互联网50 H30533\n",
      "中证白酒 399997\n",
      "'权重'\n",
      "{'ETF代码': 'H30537', 'ETF名称': '淘金100', '权重': []}\n",
      "上证消费 000036\n",
      "中证能源 000928\n",
      "细分食品 000815\n",
      "300非银 H30035\n",
      "汽车指数 931008\n",
      "中证酒 399987\n",
      "高铁产业 399807\n",
      "保险主题 399809\n",
      "'权重'\n",
      "{'ETF代码': '930734', 'ETF名称': '360互联+', '权重': []}\n",
      "'权重'\n",
      "{'ETF代码': '930729', 'ETF名称': '银智100', '权重': []}\n",
      "HK银行 930792\n",
      "中证10年国债 930916\n",
      "中证5-10年国债活跃券 931018\n",
      "HKC非银 931024\n",
      "消费龙头 931068\n",
      "CS消费50 931139\n"
     ]
    }
   ],
   "source": [
    "reach_60percent=[]\n",
    "for item in etf_list:\n",
    "    qz=item['权重']\n",
    "    df =pd.DataFrame(qz)\n",
    "    try:\n",
    "        df=df.sort_values(by='权重',ascending=False)\n",
    "        total=df.iloc[0:5]['权重'].sum()\n",
    "        if total>=59:\n",
    "            item['total']=total\n",
    "            reach_60percent.append(item)\n",
    "            print(item['ETF名称'],item['ETF代码'])\n",
    "    except Exception as e:\n",
    "        print(e)\n",
    "        print(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "reach_60percent_ =[]\n",
    "for item in reach_60percent:\n",
    "    reach_60percent_.append(item)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.DataFrame(reach_60percent_,index=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('more_than_60percent.xls',encoding='utf8',index=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>代码</th>\n",
       "      <th>名称</th>\n",
       "      <th>权重</th>\n",
       "      <th>行业</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>000100</td>\n",
       "      <td>TCL科技</td>\n",
       "      <td>2.02</td>\n",
       "      <td>可选消费</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>300014</td>\n",
       "      <td>亿纬锂能</td>\n",
       "      <td>1.81</td>\n",
       "      <td>工业</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>600438</td>\n",
       "      <td>通威股份</td>\n",
       "      <td>1.75</td>\n",
       "      <td>主要消费</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>002460</td>\n",
       "      <td>赣锋锂业</td>\n",
       "      <td>1.55</td>\n",
       "      <td>原材料</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>300124</td>\n",
       "      <td>汇川技术</td>\n",
       "      <td>1.48</td>\n",
       "      <td>工业</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       代码     名称    权重    行业\n",
       "0  000100  TCL科技  2.02  可选消费\n",
       "1  300014   亿纬锂能  1.81    工业\n",
       "2  600438   通威股份  1.75  主要消费\n",
       "3  002460   赣锋锂业  1.55   原材料\n",
       "4  300124   汇川技术  1.48    工业"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(etf_list[1]['权重'])[0:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'ETF代码': 'H00140',\n",
       " 'ETF名称': '5年国债',\n",
       " '权重': [{'代码': '019631', '名称': '20国债05', '行业': None, '权重': 25.19},\n",
       "  {'代码': '019643', '名称': '20国债13', '行业': None, '权重': 22.9},\n",
       "  {'代码': '019610', '名称': '18国债28', '行业': None, '权重': 16.46},\n",
       "  {'代码': '019635', '名称': '20特国01', '行业': None, '权重': 15.49},\n",
       "  {'代码': '019595', '名称': '18国债13', '行业': None, '权重': 10.15},\n",
       "  {'代码': '019602', '名称': '18国债20', '行业': None, '权重': 9.83}],\n",
       " '最大的个股': '20国债05',\n",
       " '最大的个股权重': 25.19,\n",
       " 'total': 90.19000000000001}"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reach_60percent_[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {},
   "outputs": [],
   "source": [
    "result=[]\n",
    "for target in reach_15percent_:\n",
    "    code = target.get('ETF代码')\n",
    "    for p in product_list:\n",
    "        if p.get('etf_code')==code:\n",
    "            p_list = p.get('etf_product')\n",
    "            result.append({'code':code,'name':target.get('ETF名称'),'基金列表':p_list})\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'code': '000914', 'name': '300金融', '基金列表': ['国投金融地产ETF联接基金', '国投瑞银金融地产ETF']},\n",
       " {'code': '000037', 'name': '上证医药', '基金列表': ['华夏医药ETF']},\n",
       " {'code': '000038', 'name': '上证金融', '基金列表': ['华夏金融ETF']},\n",
       " {'code': '000063', 'name': '上证周期', '基金列表': ['海富通上证周期ETF', '海富通上证周期ETF联接']},\n",
       " {'code': '000814',\n",
       "  'name': '细分医药',\n",
       "  '基金列表': ['华安中证医药ETF', '华安中证细分医药交易A', '华安中证细分医药交易C']},\n",
       " {'code': 'H00140', 'name': '5年国债', '基金列表': ['国泰上证5年期国债ETF']},\n",
       " {'code': '000841', 'name': '800医药', '基金列表': ['中信保诚中证800医药指数(LOF)']},\n",
       " {'code': '399966', 'name': '800证保', '基金列表': ['鹏华中证800证券保险指数(LOF)']},\n",
       " {'code': 'H30031', 'name': '800有色', '基金列表': ['中信保诚中证800有色指数(LOF)']},\n",
       " {'code': 'H11077', 'name': '10年国债', '基金列表': ['上证10年期国债ETF']},\n",
       " {'code': 'H30372', 'name': '中证安全', '基金列表': ['东海中证社会发展安全产业主题']},\n",
       " {'code': 'H30533',\n",
       "  'name': '中国互联网50',\n",
       "  '基金列表': ['易方达中证海外中国互联网50ETF',\n",
       "   '易方达中证海外联接人民币A',\n",
       "   '易方达中证海外联接美元A',\n",
       "   '易方达中证海外联接人民币C',\n",
       "   '易方达中证海外联接美元C']},\n",
       " {'code': '399997', 'name': '中证白酒', '基金列表': ['招商中证白酒指数']},\n",
       " {'code': 'H30588', 'name': '中证证保', '基金列表': ['天弘中证证券保险指数A', '天弘中证证券保险指数C']},\n",
       " {'code': 'H50069', 'name': '港股通', '基金列表': ['招商上证港股通ETF']},\n",
       " {'code': '399707',\n",
       "  'name': 'CSSW证券',\n",
       "  '基金列表': ['国泰中证申万证券行业指数(LOF)', '申万菱信中证申万证券行业指数']},\n",
       " {'code': '930651',\n",
       "  'name': 'CS计算机',\n",
       "  '基金列表': ['国泰中证计算机主题ETF',\n",
       "   '天弘中证计算机主题ETF',\n",
       "   '天弘中证计算机主题ETF联接A',\n",
       "   '天弘中证计算机主题ETF联接C',\n",
       "   '国泰中证计算机主题ETF联接A']},\n",
       " {'code': '000913',\n",
       "  'name': '300医药',\n",
       "  '基金列表': ['易方达沪深300医药ETF', '易方达沪深300医药卫生ETF联接A', '易方达沪深300医药卫生ETF联接C']},\n",
       " {'code': '000018',\n",
       "  'name': '180金融',\n",
       "  '基金列表': ['国泰上证180金融ETF', '国泰上证180金融ETF联接', '兴业上证180金融ETF']},\n",
       " {'code': '000036', 'name': '上证消费', '基金列表': ['华夏消费ETF']},\n",
       " {'code': '000042', 'name': '上证央企', '基金列表': ['工银上证央企50ETF']},\n",
       " {'code': '000928', 'name': '中证能源', '基金列表': ['汇添富中证能源ETF']},\n",
       " {'code': '000934',\n",
       "  'name': '中证金融',\n",
       "  '基金列表': ['汇添富中证金融地产ETF',\n",
       "   '嘉实中证金融地产ETF',\n",
       "   '嘉实中证金融地产ETF联接A',\n",
       "   '嘉实中证金融地产ETF联接C',\n",
       "   '长盛中证金融地产指数(LOF)']},\n",
       " {'code': '000048', 'name': '责任指数', '基金列表': ['建信上证社会责任ETF', '建信上证社会责任ETF联接']},\n",
       " {'code': '000944', 'name': '内地资源', '基金列表': ['民生加银中证内地资源主题指数']},\n",
       " {'code': '000064', 'name': '非周期', '基金列表': ['海富通上证非周期ETF', '海富通上证非周期ETF联接']},\n",
       " {'code': '000815',\n",
       "  'name': '细分食品',\n",
       "  '基金列表': ['华宝中证细分食品饮料产业主题ETF', '华夏中证细分食品饮料产业主题ETF']},\n",
       " {'code': '399965', 'name': '800地产', '基金列表': ['鹏华中证800地产指数(LOF)']},\n",
       " {'code': 'H30035',\n",
       "  'name': '300非银',\n",
       "  '基金列表': ['易方达沪深300非银ETF', '易方达沪深300非银行金融交易A', '易方达沪深300非银行金融交易C']},\n",
       " {'code': '399975',\n",
       "  'name': '证券公司',\n",
       "  '基金列表': ['国泰中证全指证券公司ETF',\n",
       "   '华宝中证全指证券公司ETF',\n",
       "   '南方全指证券联接A',\n",
       "   '南方全指证券联接C',\n",
       "   '南方中证全指证券公司ETF']},\n",
       " {'code': '399986',\n",
       "  'name': '中证银行',\n",
       "  '基金列表': ['富国中证银行指数', '南方中证银行ETF', '南方银行联接A', '南方银行联接C', '华宝中证银行ETF']},\n",
       " {'code': '931009',\n",
       "  'name': '建筑材料',\n",
       "  '基金列表': ['广发中证全指建筑材料指数A', '广发中证全指建筑材料指数C']},\n",
       " {'code': '931008', 'name': '汽车指数', '基金列表': ['广发中证全指汽车指数A', '广发中证全指汽车指数C']},\n",
       " {'code': '399987', 'name': '中证酒', '基金列表': ['鹏华中证酒ETF', '鹏华中证酒指数(LOF)']},\n",
       " {'code': '399807',\n",
       "  'name': '高铁产业',\n",
       "  '基金列表': ['南方中证高铁产业指数(LOF)', '鹏华中证高铁产业指数(LOF)']},\n",
       " {'code': '399809', 'name': '保险主题', '基金列表': ['方正富邦中证保险主题指数']},\n",
       " {'code': '930697',\n",
       "  'name': '家用电器',\n",
       "  '基金列表': ['广发中证全指家用电器指数A',\n",
       "   '广发中证全指家用电器指数C',\n",
       "   '国泰中证全指家用电器ETF',\n",
       "   '国泰中证全指家用电器ETF联接A',\n",
       "   '国泰中证全指家用电器ETF联接C']},\n",
       " {'code': '950090',\n",
       "  'name': '上证50优选',\n",
       "  '基金列表': ['华夏上证50AH优选指数(LOF)A', '华夏上证50AH优选指数(LOF)C']},\n",
       " {'code': '930792', 'name': 'HK银行', '基金列表': ['泰康香港银行指数A', '泰康香港银行指数C']},\n",
       " {'code': '950105', 'name': '上证证券', '基金列表': ['汇安上证证券ETF']},\n",
       " {'code': '930916', 'name': '中证10年国债', '基金列表': ['富国中证10年期国债ETF']},\n",
       " {'code': '931018', 'name': '中证5-10年国债活跃券', '基金列表': ['平安中证5-10年期国债活跃券ETF']},\n",
       " {'code': '931024', 'name': 'HKC非银', '基金列表': ['泰康中证港股通非银指数A', '泰康中证港股通非银指数C']},\n",
       " {'code': '930738',\n",
       "  'name': '四川国改',\n",
       "  '基金列表': ['华夏中证四川国改ETF', '华夏中证四川国改发起式ETF联接A', '华夏中证四川国改发起式ETF联接C']},\n",
       " {'code': '931068',\n",
       "  'name': '消费龙头',\n",
       "  '基金列表': ['华宝中证消费龙头指数(LOF)A', '华宝中证消费龙头指数(LOF)C']},\n",
       " {'code': '931139',\n",
       "  'name': 'CS消费50',\n",
       "  '基金列表': ['富国中证消费50ETF',\n",
       "   '富国中证消费50ETF联接A',\n",
       "   '富国中证消费50ETF联接C',\n",
       "   '东兴中证消费50指数A',\n",
       "   '东兴中证消费50指数C']},\n",
       " {'code': '931372',\n",
       "  'name': '浙江国资',\n",
       "  '基金列表': ['华夏中证浙江国资创新发展ETF', '华夏中证浙江国资创新发展ETF联接A', '华夏中证浙江国资创新发展ETF联接C']}]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(result)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('fund_list_15percent.xls',encoding='utf8',index=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [],
   "source": [
    "result_60percent=[]\n",
    "for target in reach_60percent_:\n",
    "    code = target.get('ETF代码')\n",
    "    for p in product_list:\n",
    "        if p.get('etf_code')==code:\n",
    "            p_list = p.get('etf_product')\n",
    "            result_60percent.append({'code':code,'name':target.get('ETF名称'),'基金列表':p_list})\n",
    "            break"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.DataFrame(result_60percent)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_excel('fund_list_60percent.xls',encoding='utf8',index=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
